﻿ 
INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode], [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB10', 1, 0,'BB10', N'系统管理', 1, NULL, NULL, NULL, 1, NULL, GETDATE())
INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID], [PathCode], [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB20', 1, 0,N'BB20', N'基础信息管理', 2, NULL, NULL, NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB1001', 2, N'BB10','BB10.BB1001', N'系统参数', 1, NULL, N'~/BBSSystem/SystemSettings.html', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))
INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID], [PathCode], [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB1002', 2, N'BB10','BB10.BB1002', N'用户信息', 2, NULL, N'~/BackUsers/Index.html', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB2001', 2, N'BB20','BB20.BB2001', N'新闻管理', 1, NULL, N'~/BackNews/Index.html', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID], [PathCode], [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
VALUES (N'BACKBBS', N'BB2002', 2, N'BB20','BB20.BB2002', N'彩种信息管理', 2, NULL, N'~/BackPlays/Index.html', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))


--INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
--VALUES (N'BACKBBS', N'BB200101', 2, N'BB2001','BB20.BB2001.BB200101', N'新闻管理的儿子', 1, NULL, N'', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

--INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
--VALUES (N'BACKBBS', N'BB20010101', 2, N'BB200101','BB20.BB2001.BB200101.BB20010101.BB20010101', N'新闻管理的孙子1', 1, NULL, N'', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

--INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
--VALUES (N'BACKBBS', N'BB20010102', 2, N'BB200101','BB20.BB2001.BB200101.BB20010101.BB20010102', N'新闻管理的孙子2', 1, NULL, N'~/BackNews/Index.html?BB20010102', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

--INSERT UAMenuInfo ([MenuType], [MenuID], [MenuLevel], [ParentMenuID],[PathCode],  [MenuName], [OrderID], [ImageURL], [LinkURL], [Comments], [IsVisible], [OpenTarget], [CreateTime]) 
--VALUES (N'BACKBBS', N'BB2001010101', 2, N'BB20010101','BB20.BB2001.BB200101.BB20010101.BB20010101.BB2001010101',
-- N'新闻管理的孙子1的儿子', 1, NULL, N'~/BackNews/Index.html?BB2001010101', NULL, 1, NULL, CAST(0x0000A0640119EFED AS DateTime))

select * from UAMenuInfo;
-- TRUNCATE TABLE UAMenuInfo;